package com.quo.mapper;

import java.util.List;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import com.quo.entity.Emp;
import com.quo.entity.EmpLogin;

/**
 * 
 * @author 韩宛廷
 *
 */
@Mapper
public interface EmpMapper {

	
    @Select("select * from emp where eno = #{eno} and pwd = #{pwd}")
	EmpLogin getByEnoAndPwd(@Param("eno")int enoint, @Param("pwd")String pwd);


	@Update("update emp set pwd=#{pwd} where eno=#{eno}")
	int changePwd(Emp emp);

	/**
	 * 
	 * @author zhoumin
	 *
	 */
	@Select("select * from emp where eno = #{eno} and pwd = #{pwd}")
	Emp getEmp(@Param("eno")int eno, @Param("pwd")String pwd);
	
}
